SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 59257: The SYSDBRC macro variable does not contain the return code from the last step against a database

DetailsHotfixAboutRate It

When you use SAS/ACCESS® software to access your database management system (DBMS) data, the macro variable SYSDBRC shows the last DBMS-specific return code that was generated. You might encounter a problem under z/OS in which running a step with BULKLOAD=YES against a DB2 table does not surface the return code to the job. In this scenario, the macro variable SYSDBRC is 0 and the return code for the job is also 0. When you encounter this problem, you must look at the output of the LOAD utility to determine whether the last step failed.

There is no workaround for this issue.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to DB2z/OS9.3 TS1M29.4 TS1M4
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.